/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 1009

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 49 4e | 53 45 52 54 20 53 45 54 |CHILD IN|SERT SET|
|00000010| 4e 55 4c 4c 00 20 20 20 | 20 2d 2d 20 45 52 77 69 |NULL.   | -- ERwi|
|00000020| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00000030| 69 6d 65 0d 0a 20 20 20 | 20 2d 2d 20 25 50 61 72 |ime..   | -- %Par|
|00000040| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|00000050| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|00000060| 49 4e 53 45 52 54 20 53 | 45 54 20 4e 55 4c 4c 20 |INSERT S|ET NULL |
|00000070| 0d 0a 20 20 20 20 28 75 | 70 64 61 74 65 20 25 43 |..    (u|pdate %C|
|00000080| 68 69 6c 64 0d 0a 20 20 | 20 20 20 20 73 65 74 0d |hild..  |    set.|
|00000090| 0a 20 20 20 20 20 20 20 | 20 2d 2d 20 25 25 53 65 |.       | -- %%Se|
|000000a0| 74 46 4b 28 25 43 68 69 | 6c 64 2c 4e 55 4c 4c 29 |tFK(%Chi|ld,NULL)|
|000000b0| 20 0d 0a 20 20 20 20 20 | 20 20 20 25 53 65 74 46 | ..     |   %SetF|
|000000c0| 4b 28 25 43 68 69 6c 64 | 2c 4e 55 4c 4c 29 0d 0a |K(%Child|,NULL)..|
|000000d0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 |      wh|ere..   |
|000000e0| 20 20 20 20 20 2d 2d 20 | 25 25 4a 6f 69 6e 50 4b |     -- |%%JoinPK|
|000000f0| 50 4b 28 69 6e 73 65 72 | 74 65 64 2c 25 43 68 69 |PK(inser|ted,%Chi|
|00000100| 6c 64 2c 22 20 3d 20 22 | 2c 22 20 61 6e 64 22 29 |ld," = "|," and")|
|00000110| 20 0d 0a 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e | ..     |   %Join|
|00000120| 50 4b 50 4b 28 69 6e 73 | 65 72 74 65 64 2c 25 43 |PKPK(ins|erted,%C|
|00000130| 68 69 6c 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |hild," =| "," and|
|00000140| 22 29 20 61 6e 64 0d 0a | 20 20 20 20 20 20 20 20 |") and..|        |
|00000150| 6e 6f 74 20 65 78 69 73 | 74 73 20 28 0d 0a 20 20 |not exis|ts (..  |
|00000160| 20 20 20 20 20 20 20 20 | 73 65 6c 65 63 74 20 2a |        |select *|
|00000170| 20 66 72 6f 6d 20 25 50 | 61 72 65 6e 74 0d 0a 20 | from %P|arent.. |
|00000180| 20 20 20 20 20 20 20 20 | 20 77 68 65 72 65 0d 0a |        | where..|
|00000190| 20 20 20 20 20 20 20 20 | 20 20 20 20 2d 2d 20 25 |        |    -- %|
|000001a0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 69 6e 73 65 72 74 |%JoinFKP|K(insert|
|000001b0| 65 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ed,%Pare|nt," = "|
|000001c0| 2c 22 20 61 6e 64 22 29 | 20 0d 0a 20 20 20 20 20 |," and")| ..     |
|000001d0| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b |       %|JoinFKPK|
|000001e0| 28 69 6e 73 65 72 74 65 | 64 2c 25 50 61 72 65 6e |(inserte|d,%Paren|
|000001f0| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 0d |t," = ",|" and").|
|00000200| 0a 20 20 20 20 20 20 20 | 20 29 0d 0a 20 20 20 20 |.       | )..    |
|00000210| 29 2c 0d 0a 00 1a 27    |                         |),....' |        |
+--------+-------------------------+-------------------------+--------+--------+